﻿<?xml version="1.0" encoding="utf-8" ?>
<storedprocs>
  <SP name="LLUser_CreateLLUser">
    <parameters>
      <parameter name="ApplicationName"   type="string" defaultValue="" direction="in" />
      <parameter name="UserName"          type="string" defaultValue="" direction="in" />
      <parameter name="FirstName"         type="string" defaultValue="" direction="in" />
      <parameter name="LastName"          type="string" defaultValue="" direction="in" />
      <parameter name="Gender"            type="string" defaultValue="" direction="in" />
      <parameter name="AccounntStatus"    type="int32" defaultValue="" direction="in" />
      <parameter name="AccountType"       type="int32" defaultValue="" direction="in" />
    </parameters>
  </SP>
  <SP name="PBDsk_Upsert_GigyaMapper">
    <parameters>
      <parameter name="pGigyaUID"   type="string" defaultValue="" direction="in" />
      <parameter name="pCMSEmail"   type="string" defaultValue="" direction="in" />
      <parameter name="pIsActive"   type="boolean" defaultValue="" direction="in" />
    </parameters>
  </SP>
  <SP name="PBDsk_GetUserNameFromGigyaMapper">
    <parameters>
      <parameter name="pGigyaUID"   type="string" defaultValue="" direction="in" />
    </parameters>
  </SP>
  <SP name="PBDsk_Upsert_GigyaUser">
    <parameters>
      <parameter name="pGigyaUID"   type="string" defaultValue="" direction="in" />
      <parameter name="pLoginProvider"   type="string" defaultValue="" direction="in" />
      <parameter name="pLoginProviderUID"   type="string" defaultValue="" direction="in" />
      <parameter name="pNickName"   type="string" defaultValue="" direction="in" />
      <parameter name="pEmail"   type="string" defaultValue="" direction="in" />
      <parameter name="pFName"   type="string" defaultValue="" direction="in" />
      <parameter name="pLName"   type="string" defaultValue="" direction="in" />
      <parameter name="pGender"   type="string" defaultValue="" direction="in" />
      <parameter name="pDateOfBirth"   type="datetime" defaultValue="" direction="in" />
      <parameter name="pCity"   type="string" defaultValue="" direction="in" />
      <parameter name="pState"   type="string" defaultValue="" direction="in" />
      <parameter name="pCountry"   type="string" defaultValue="" direction="in" />
      <parameter name="pZIP"   type="string" defaultValue="" direction="in" />
      <parameter name="pPhotoUrl"   type="string" defaultValue="" direction="in" />
      <parameter name="pThumbnailUrl"   type="string" defaultValue="" direction="in" />
      <parameter name="pProfileUrl"   type="string" defaultValue="" direction="in" />
      <parameter name="pIsActive"   type="boolean" defaultValue="" direction="in" />
    </parameters>
  </SP>  
  <SP name="Test_Proc">
    <parameters>
      <parameter name="ApplicationName"   type="string" defaultValue="" direction="in" />
      <parameter name="param1"          type="string" defaultValue="" direction="in" />
      <parameter name="param2"          type="string" defaultValue="" direction="out" />
    </parameters>
  </SP>
  <SP name="PBDsk_GetChannelList">
    <parameters>      
    </parameters>
  </SP>
  <SP name="PBDsk_InsertFeedNewsItem">
    <parameters>
      <parameter name="pChannelID"          type="int32" defaultValue="" direction="in" />
      <parameter name="pTitle"         type="string" defaultValue="" direction="in" />
      <parameter name="pDescription"          type="string" defaultValue="" direction="in" />
      <parameter name="pLink"            type="string" defaultValue="" direction="in" />
      <parameter name="pPubDate"    type="datetime" defaultValue="" direction="in" />
      <parameter name="pAuthor"       type="string" defaultValue="" direction="in" />
      <parameter name="pIsActive"   type="boolean" defaultValue="" direction="in" />
    </parameters>
  </SP>
  <SP name="PBDsk_GetFeedsNewsItems">
    <parameters>
      <parameter name="pChannelID"          type="int32" defaultValue="" direction="in" />
      <parameter name="pCount"              type="int32" defaultValue="" direction="in" />
    </parameters>
  </SP>
  
</storedprocs>